USE [LandmarkJefferson]
GO

/****** Object:  View [dbo].[MarriageDocsAlabamaJefferson]    Script Date: 10/26/2015 8:46:38 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO








ALTER VIEW [dbo].[MarriageDocsAlabamaJefferson]
AS
SELECT
	-- id
	[Id]
	,[OrderId]
	,[DocumentTypeId]
	,
	-- common to both bride and groom
	DateField3 AS DateLicenseEffect
	,DateField5 AS MarriageDate
	,DateField4 AS ExpirationDate
	,TextField62 as PerformedBy
    ,TextField61 as CountyMarried
    ,TextField60 as CityMarried
	,
	--Groom specific
	TextField30 AS GroomGender
	,ComboField1 as GroomRace
	,TextField1 AS GroomFirstName
	,TextField12 AS GroomMiddleName
	,TextField13 AS GroomLastName
	,TextField28 AS GroomBirthName
	,TextField20 AS GroomSuffixName
	,TextField15 AS GroomStreetAddress
	,TextField21 AS GroomCity
	,TextField16 AS GroomState
	,TextField23 AS GroomZip
		,BitField10 as GroomAddressInsideCityLimits
		,TextField14 as GoomCounty
	,TextField24 AS GroomPhone
	,DateField1 AS GroomDOB
	,TextField75 AS GroomBirthCity
	,TextField17 AS GroomBirthStateOrCountry
	,TextField36 AS GroomGuardianFatherFirstName
	,TextField37 AS GroomGuardianFatherMiddleName
	,TextField38 AS GroomGuardianFatherLastName
	,TextField70 AS GroomAllLegalNamesOtherThanBirthOrCurrent
	,ComboField5 as GroomEducation
	,BitField1 as GroomEverMarried
	,TextField8 as GroomNumberOfPreviousMarriages
	,ComboField2 as GroomHowLastMarriageEnded
	
	-- Bride or Party2
	,TextField31 AS BrideGender
	,ComboField3 as BrideRace
	,TextField18 AS BrideFirstName
	,TextField19 AS BrideMiddleName
	,TextField10 AS BrideLastName
	,TextField29 AS BrideSuffixName
	,TextField2 AS BrideMaidenName
	,TextField22 AS BrideStreetAddress
	,TextField3 AS BrideCity
	,TextField5 AS BrideState
	,TextField26 AS BrideZip
	,BitField9 as BrideAddressInsideCityLimits
	,TextField4 as BrideCounty
	,DateField2 AS BrideDOB
	,TextField27 AS BridePhone
	,TextField74 AS BrideBirthCity
	,TextField6 AS BrideBirthStateOrCountry
	,textField46 AS BrideGuardianFatherFirstName
	,textField47 AS BrideGuardianFatherMiddleName
	,textField48 AS BrideGuardianFatherLastName
	,TextField49 AS BrideGuardianMotherFirstName
	,TextField50 AS BrideGuardianMotherMiddleName
	,TextField51 AS BrideGuardianMotherLastName
	,TextField71 AS BrideAllLegalNamesOtherThanBirthOrCurrent
	,ComboField6 as BrideEducation
	,BitField2 as BrideEverMarried
	,TextField11 as BrideroomNumberOfPreviousMarriages
	,ComboField4 as BrideHowLastMarriageEnded

	FROM document
WHERE [DocumentTypeId] IN (795,798,580,794,801)







GO